/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / Logic Works ERwin 3.5 / data.1 / ERTMPL32.DLL / RCDATA / 711

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 43 41 53 |CHILD UP|DATE CAS|
|00000010| 43 41 44 45 00 21 20 45 | 52 77 69 6e 20 42 75 69 |CADE.! E|Rwin Bui|
|00000020| 6c 74 69 6e 20 25 44 61 | 74 65 74 69 6d 65 20 0d |ltin %Da|tetime .|
|00000030| 0a 21 20 25 50 61 72 65 | 6e 74 20 25 56 65 72 62 |.! %Pare|nt %Verb|
|00000040| 50 68 72 61 73 65 20 25 | 43 68 69 6c 64 20 4f 4e |Phrase %|Child ON|
|00000050| 20 43 48 49 4c 44 20 55 | 50 44 41 54 45 20 43 41 | CHILD U|PDATE CA|
|00000060| 53 43 41 44 45 20 0d 0a | 20 20 20 20 63 61 6c 6c |SCADE ..|    call|
|00000070| 20 53 71 6c 49 6d 6d 65 | 64 69 61 74 65 28 27 73 | SqlImme|diate('s|
|00000080| 65 6c 65 63 74 20 63 6f | 75 6e 74 28 2a 29 20 69 |elect co|unt(*) i|
|00000090| 6e 74 6f 20 3a 6e 75 6d | 72 6f 77 73 20 66 72 6f |nto :num|rows fro|
|000000a0| 6d 20 25 50 61 72 65 6e | 74 20 77 68 65 72 65 20 |m %Paren|t where |
|000000b0| 25 46 6f 72 45 61 63 68 | 46 4b 41 74 74 28 22 61 |%ForEach|FKAtt("a|
|000000c0| 6e 64 20 22 29 7b 20 25 | 50 61 72 65 6e 74 2e 25 |nd "){ %|Parent.%|
|000000d0| 50 61 72 65 6e 74 41 74 | 74 28 25 41 74 74 46 69 |ParentAt|t(%AttFi|
|000000e0| 65 6c 64 4e 61 6d 65 29 | 20 3d 20 3a 6e 25 31 37 |eldName)| = :n%17|
|000000f0| 41 74 74 46 69 65 6c 64 | 4e 61 6d 65 20 7d 27 29 |AttField|Name }')|
|00000100| 0d 0a 20 20 20 20 69 66 | 20 6e 75 6d 72 6f 77 73 |..    if| numrows|
|00000110| 20 3d 20 30 0d 0a 09 20 | 20 20 63 61 6c 6c 20 73 | = 0... |  call s|
|00000120| 71 6c 69 6d 6d 65 64 69 | 61 74 65 28 27 69 6e 73 |qlimmedi|ate('ins|
|00000130| 65 72 74 20 69 6e 74 6f | 20 25 50 61 72 65 6e 74 |ert into| %Parent|
|00000140| 20 28 25 50 61 72 65 6e | 74 50 4b 28 22 2c 22 2c | (%Paren|tPK(",",|
|00000150| 29 29 0d 0a 20 20 20 20 | 20 20 76 61 6c 75 65 73 |))..    |  values|
|00000160| 20 28 25 46 6f 72 45 61 | 63 68 46 4b 41 74 74 28 | (%ForEa|chFKAtt(|
|00000170| 22 2c 20 22 29 7b 3a 6e | 25 31 37 41 74 74 46 69 |", "){:n|%17AttFi|
|00000180| 65 6c 64 4e 61 6d 65 7d | 29 27 29 0d 0a 00 1d 27 |eldName}|)')....'|
+--------+-------------------------+-------------------------+--------+--------+